﻿USE ASERDB
GO
CREATE TABLE [dbo].[NoRecordor](
	[Table_nam] [varchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[LastBillDate] [datetime] NULL,
	[Bill_no] [varchar](20) COLLATE Chinese_PRC_CI_AS NULL,
	[LastIdDate] [datetime] NULL,
	[Line_id] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[Table_nam] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[PreFixTable](
	[TableName] [varchar](100) COLLATE Chinese_PRC_CI_AS NOT NULL,
	[PreFix] [varchar](3) COLLATE Chinese_PRC_CI_AS NULL,
	[Comment] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
PRIMARY KEY CLUSTERED 
(
	[TableName] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO

